Pokemon Project Profiling

Dataset statistics

Number of variables	14
Number of observations	800
Missing cells	386
Missing cells (%)	3.4%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	87.6 KiB
Average record size in memory	112.2 B

Variable types

NUM	9
CAT	3
BOOL	2

Reproduction

Analysis started	2020-06-02 21:21:28.719419
Analysis finished	2020-06-02 21:21:50.185813
Duration	21.47 seconds
Version	pandas-profiling v2.8.0
Command line	`pandas_profiling --config_file config.yaml [YOUR_FILE.csv]`
Download configuration	config.yaml

Warnings

`Gen` is highly correlated with `#`	High correlation
`#` is highly correlated with `Gen`	High correlation
`Type 2` has 386 (48.3%) missing values	Missing
`#` is uniformly distributed	Uniform
`Name` has unique values	Unique

#
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM

Distinct count	721
Unique (%)	90.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	362.81375
Minimum	1
Maximum	721
Zeros	0
Zeros (%)	0.0%
Memory size	6.2 KiB

Quantile statistics

Minimum	1
5-th percentile	34.95
Q1	184.75
median	364.5
Q3	539.25
95-th percentile	689.05
Maximum	721
Range	720
Interquartile range (IQR)	354.5

Descriptive statistics

Standard deviation	208.3437976
Coefficient of variation (CV)	0.574244492
Kurtosis	-1.165705095
Mean	362.81375
Median Absolute Deviation (MAD)	177.5
Skewness	-0.001122502762
Sum	290251
Variance	43407.13798

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
479	6	0.8%
386	4	0.5%
711	4	0.5%
710	4	0.5%
150	3	0.4%
6	3	0.4%
413	3	0.4%
646	3	0.4%
303	2	0.2%
302	2	0.2%
Other values (711)	766	95.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.1%
2	1	0.1%
3	2	0.2%
4	1	0.1%
5	1	0.1%

Value	Count	Frequency (%)
721	1	0.1%
720	2	0.2%
719	2	0.2%
718	1	0.1%
717	1	0.1%

Name
Categorical

UNIQUE

Distinct count	800
Unique (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	6.2 KiB

Nidorino	1
Absol	1
ShayminSky Forme	1
Sandile	1
DeoxysNormal Forme	1
Other values (795)	795

Common Values
Length

Value	Count	Frequency (%)
Nidorino	1	0.1%
Absol	1	0.1%
ShayminSky Forme	1	0.1%
Sandile	1	0.1%
DeoxysNormal Forme	1	0.1%
Registeel	1	0.1%
Drowzee	1	0.1%
Typhlosion	1	0.1%
Krookodile	1	0.1%
Lickitung	1	0.1%
Other values (790)	790	98.8%

Length

Max length	25
Median length	8
Mean length	8.84125
Min length	3

Type 1
Categorical

Distinct count	18
Unique (%)	2.2%
Missing	0
Missing (%)	0.0%
Memory size	6.2 KiB

Water	112
Normal	98
Grass	70
Bug	69
Psychic	57
Other values (13)	394

Common Values
Length

Value	Count	Frequency (%)
Water	112	14.0%
Normal	98	12.2%
Grass	70	8.8%
Bug	69	8.6%
Psychic	57	7.1%
Fire	52	6.5%
Electric	44	5.5%
Rock	44	5.5%
Ground	32	4.0%
Ghost	32	4.0%
Other values (8)	190	23.8%

Length

Max length	8
Median length	5
Mean length	5.26
Min length	3

Type 2
Categorical

MISSING

Distinct count	18
Unique (%)	4.3%
Missing	386
Missing (%)	48.3%
Memory size	6.2 KiB

Flying	97
Ground	35
Poison	34
Psychic	33
Fighting	26
Other values (13)	189

Common Values
Length

Value	Count	Frequency (%)
Flying	97	12.1%
Ground	35	4.4%
Poison	34	4.2%
Psychic	33	4.1%
Fighting	26	3.2%
Grass	25	3.1%
Fairy	23	2.9%
Steel	22	2.8%
Dark	20	2.5%
Dragon	18	2.2%
Other values (8)	81	10.1%
(Missing)	386	48.2%

Length

Max length	8
Median length	3
Mean length	4.3725
Min length	3

Total
Real number (ℝ_≥0)

Distinct count	200
Unique (%)	25.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	435.1025
Minimum	180
Maximum	780
Zeros	0
Zeros (%)	0.0%
Memory size	6.2 KiB

Quantile statistics

Minimum	180
5-th percentile	250
Q1	330
median	450
Q3	515
95-th percentile	630
Maximum	780
Range	600
Interquartile range (IQR)	185

Descriptive statistics

Standard deviation	119.9630398
Coefficient of variation (CV)	0.2757121362
Kurtosis	-0.5074607103
Mean	435.1025
Median Absolute Deviation (MAD)	85
Skewness	0.1525299234
Sum	348082
Variance	14391.13091

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
600	37	4.6%
405	26	3.2%
500	23	2.9%
580	23	2.9%
300	19	2.4%
490	18	2.2%
525	16	2.0%
480	15	1.9%
495	15	1.9%
330	15	1.9%
Other values (190)	593	74.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
180	1	0.1%
190	1	0.1%
194	1	0.1%
195	3	0.4%
198	1	0.1%

Value	Count	Frequency (%)
780	3	0.4%
770	2	0.2%
720	1	0.1%
700	9	1.1%
680	13	1.6%

HP
Real number (ℝ_≥0)

Distinct count	94
Unique (%)	11.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	69.25875
Minimum	1
Maximum	255
Zeros	0
Zeros (%)	0.0%
Memory size	6.2 KiB

Quantile statistics

Minimum	1
5-th percentile	35.95
Q1	50
median	65
Q3	80
95-th percentile	110
Maximum	255
Range	254
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	25.53466903
Coefficient of variation (CV)	0.368685098
Kurtosis	7.232078374
Mean	69.25875
Median Absolute Deviation (MAD)	15
Skewness	1.568224376
Sum	55407
Variance	652.0193226

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
60	67	8.4%
50	63	7.9%
70	57	7.1%
65	46	5.8%
75	43	5.4%
80	43	5.4%
40	38	4.8%
45	38	4.8%
55	37	4.6%
100	32	4.0%
Other values (84)	336	42.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	0.1%
10	1	0.1%
20	6	0.8%
25	2	0.2%
28	1	0.1%

Value	Count	Frequency (%)
255	1	0.1%
250	1	0.1%
190	1	0.1%
170	1	0.1%
165	1	0.1%

Atk
Real number (ℝ_≥0)

Distinct count	111
Unique (%)	13.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	79.00125
Minimum	5
Maximum	190
Zeros	0
Zeros (%)	0.0%
Memory size	6.2 KiB

Quantile statistics

Minimum	5
5-th percentile	30
Q1	55
median	75
Q3	100
95-th percentile	136.2
Maximum	190
Range	185
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	32.45736587
Coefficient of variation (CV)	0.4108462318
Kurtosis	0.1697173149
Mean	79.00125
Median Absolute Deviation (MAD)	20
Skewness	0.551613748
Sum	63201
Variance	1053.480599

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
100	40	5.0%
65	39	4.9%
80	37	4.6%
50	37	4.6%
85	33	4.1%
60	33	4.1%
75	32	4.0%
70	31	3.9%
90	30	3.8%
55	30	3.8%
Other values (101)	458	57.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	2	0.2%
10	3	0.4%
15	1	0.1%
20	8	1.0%
22	1	0.1%

Value	Count	Frequency (%)
190	1	0.1%
185	1	0.1%
180	3	0.4%
170	2	0.2%
165	3	0.4%

Def
Real number (ℝ_≥0)

Distinct count	103
Unique (%)	12.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	73.8425
Minimum	5
Maximum	230
Zeros	0
Zeros (%)	0.0%
Memory size	6.2 KiB

Quantile statistics

Minimum	5
5-th percentile	35
Q1	50
median	70
Q3	90
95-th percentile	130
Maximum	230
Range	225
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	31.18350056
Coefficient of variation (CV)	0.422297465
Kurtosis	2.72626036
Mean	73.8425
Median Absolute Deviation (MAD)	20
Skewness	1.155912303
Sum	59074
Variance	972.4107071

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
70	54	6.8%
50	49	6.1%
60	46	5.8%
80	39	4.9%
40	36	4.5%
65	36	4.5%
90	35	4.4%
100	33	4.1%
55	32	4.0%
45	32	4.0%
Other values (93)	408	51.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	2	0.2%
10	1	0.1%
15	4	0.5%
20	4	0.5%
23	1	0.1%

Value	Count	Frequency (%)
230	3	0.4%
200	2	0.2%
184	1	0.1%
180	3	0.4%
168	1	0.1%

Sp. Atk
Real number (ℝ_≥0)

Distinct count	105
Unique (%)	13.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	72.82
Minimum	10
Maximum	194
Zeros	0
Zeros (%)	0.0%
Memory size	6.2 KiB

Quantile statistics

Minimum	10
5-th percentile	30
Q1	49.75
median	65
Q3	95
95-th percentile	131.05
Maximum	194
Range	184
Interquartile range (IQR)	45.25

Descriptive statistics

Standard deviation	32.72229417
Coefficient of variation (CV)	0.4493586126
Kurtosis	0.2978936607
Mean	72.82
Median Absolute Deviation (MAD)	20
Skewness	0.7446624978
Sum	58256
Variance	1070.748536

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
60	51	6.4%
40	49	6.1%
65	44	5.5%
50	39	4.9%
55	35	4.4%
45	33	4.1%
70	30	3.8%
35	29	3.6%
85	27	3.4%
80	27	3.4%
Other values (95)	436	54.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
10	3	0.4%
15	4	0.5%
20	8	1.0%
23	1	0.1%
24	2	0.2%

Value	Count	Frequency (%)
194	1	0.1%
180	3	0.4%
175	1	0.1%
170	3	0.4%
165	2	0.2%

Sp. Def
Real number (ℝ_≥0)

Distinct count	92
Unique (%)	11.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	71.9025
Minimum	20
Maximum	230
Zeros	0
Zeros (%)	0.0%
Memory size	6.2 KiB

Quantile statistics

Minimum	20
5-th percentile	32.95
Q1	50
median	70
Q3	90
95-th percentile	120
Maximum	230
Range	210
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	27.8289158
Coefficient of variation (CV)	0.3870368318
Kurtosis	1.628394057
Mean	71.9025
Median Absolute Deviation (MAD)	20
Skewness	0.8540186115
Sum	57522
Variance	774.4485544

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
80	52	6.5%
50	50	6.2%
55	47	5.9%
65	44	5.5%
60	43	5.4%
75	40	5.0%
70	40	5.0%
90	36	4.5%
45	35	4.4%
85	30	3.8%
Other values (82)	383	47.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
20	6	0.8%
23	1	0.1%
25	11	1.4%
30	20	2.5%
31	1	0.1%

Value	Count	Frequency (%)
230	1	0.1%
200	1	0.1%
160	2	0.2%
154	3	0.4%
150	7	0.9%

Spd
Real number (ℝ_≥0)

Distinct count	108
Unique (%)	13.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	68.2775
Minimum	5
Maximum	180
Zeros	0
Zeros (%)	0.0%
Memory size	6.2 KiB

Quantile statistics

Minimum	5
5-th percentile	25
Q1	45
median	65
Q3	90
95-th percentile	115
Maximum	180
Range	175
Interquartile range (IQR)	45

Descriptive statistics

Standard deviation	29.06047372
Coefficient of variation (CV)	0.4256229903
Kurtosis	-0.2364366728
Mean	68.2775
Median Absolute Deviation (MAD)	21
Skewness	0.3579332951
Sum	54622
Variance	844.5111327

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
50	46	5.8%
60	44	5.5%
70	37	4.6%
65	36	4.5%
30	35	4.4%
80	33	4.1%
40	32	4.0%
90	31	3.9%
100	31	3.9%
55	30	3.8%
Other values (98)	445	55.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
5	2	0.2%
10	3	0.4%
15	9	1.1%
20	15	1.9%
22	1	0.1%

Value	Count	Frequency (%)
180	1	0.1%
160	1	0.1%
150	4	0.5%
145	3	0.4%
140	2	0.2%

Gen
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct count	6
Unique (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.32375
Minimum	1
Maximum	6
Zeros	0
Zeros (%)	0.0%
Memory size	6.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	5
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6612904
Coefficient of variation (CV)	0.4998241145
Kurtosis	-1.239575758
Mean	3.32375
Median Absolute Deviation (MAD)	2
Skewness	0.01425810028
Sum	2659
Variance	2.759885795

Histogram

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1	166	20.8%
5	165	20.6%
3	160	20.0%
4	121	15.1%
2	106	13.2%
6	82	10.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	166	20.8%
2	106	13.2%
3	160	20.0%
4	121	15.1%
5	165	20.6%

Value	Count	Frequency (%)
6	82	10.2%
5	165	20.6%
4	121	15.1%
3	160	20.0%
2	106	13.2%

Legendary
Boolean

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	6.2 KiB

0	734
1	66

Frequency Table

Value	Count	Frequency (%)
0	734	91.8%
1	66	8.2%

Mega
Boolean

Distinct count	2
Unique (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	6.2 KiB

0	751
1	49

Frequency Table

Value	Count	Frequency (%)
0	751	93.9%
1	49	6.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	#	Name	Type 1	Type 2	Total	HP	Atk	Def	Sp. Atk	Sp. Def	Spd	Gen	Mega
0	1	Bulbasaur	Grass	Poison	318	45	49	49	65	65	45	1	0
1	2	Ivysaur	Grass	Poison	405	60	62	63	80	80	60	1	0
2	3	Venusaur	Grass	Poison	525	80	82	83	100	100	80	1	0
3	3	VenusaurMega Venusaur	Grass	Poison	625	80	100	123	122	120	80	1	1
4	4	Charmander	Fire	NaN	309	39	52	43	60	50	65	1	0
5	5	Charmeleon	Fire	NaN	405	58	64	58	80	65	80	1	0
6	6	Charizard	Fire	Flying	534	78	84	78	109	85	100	1	0
7	6	CharizardMega Charizard X	Fire	Dragon	634	78	130	111	130	85	100	1	1
8	6	CharizardMega Charizard Y	Fire	Flying	634	78	104	78	159	115	100	1	1
9	7	Squirtle	Water	NaN	314	44	48	65	50	64	43	1	0

Last rows

	#	Name	Type 1	Type 2	Total	HP	Atk	Def	Sp. Atk	Sp. Def	Spd	Gen	Legendary	Mega
790	714	Noibat	Flying	Dragon	245	40	30	35	45	40	55	6	0	0
791	715	Noivern	Flying	Dragon	535	85	70	80	97	80	123	6	0	0
792	716	Xerneas	Fairy	NaN	680	126	131	95	131	98	99	6	1	0
793	717	Yveltal	Dark	Flying	680	126	131	95	131	98	99	6	1	0
794	718	Zygarde50% Forme	Dragon	Ground	600	108	100	121	81	95	95	6	1	0
795	719	Diancie	Rock	Fairy	600	50	100	150	100	150	50	6	1	0
796	719	DiancieMega Diancie	Rock	Fairy	700	50	160	110	160	110	110	6	1	1
797	720	HoopaHoopa Confined	Psychic	Ghost	600	80	110	60	150	130	70	6	1	0
798	720	HoopaHoopa Unbound	Psychic	Dark	680	80	160	60	170	130	80	6	1	0
799	721	Volcanion	Fire	Water	600	80	110	120	130	90	70	6	1	0

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows